Executive Summary and Troubles that Occurred
3
Executive Summary

Troubles that Occurred during the project.
- There was a lot of data stored in different Excel Sheets, columns like the Geography Country and State merged, duplicates. The data needed a lot of cleaning. I used SSIS, SQL and elimination, modification in Excel.
- The data is reported at the end of each Year that is 31st December. Which limited the date granularity in which I visualize the data, However I utilized the year as a filter to see the insights in the various programs, regions, States and Income levels.
- Using Year over Year measures over the views was a challenge. I did a lot of research on the topic.

1.
Sample of an Executive Overview Dashboard: https://www.youtube.com/watch?v=gapji0KMqUA